SetThemeColors

Sets the theme colors to the current spreadsheet.

Syntax

expression.SetThemeColors(sTheme);

expression - A variable that represents a Api class.

Parameters

Name	Required/Optional	Data type	Default	Description
sTheme	Required	string		The color scheme that will be set to the current spreadsheet.

Returns

boolean

Example

This example sets the theme colors to the current spreadsheet.

var oWorksheet = Api.GetActiveSheet();
var themes = Api.GetThemesColors();
for (let i = 0; i < themes.length; ++i) {
	oWorksheet.GetRange("A" + (i + 1)).SetValue(themes[i]);
}
Api.SetThemeColors(themes[3]);
oWorksheet.GetRange("C3").SetValue("The 'Apex' theme colors were set to the current spreadsheet.");